/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50151
Source Host           : localhost:3306
Source Database       : silentwebsitedb

Target Server Type    : MYSQL
Target Server Version : 50151
File Encoding         : 65001

Date: 2013-04-16 14:31:39
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `dynamiccontrol`
-- ----------------------------
DROP TABLE IF EXISTS `dynamiccontrol`;
CREATE TABLE `dynamiccontrol` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Name` varchar(200) DEFAULT NULL,
  `ClrType` varchar(400) DEFAULT NULL,
  `Description` varchar(400) DEFAULT NULL,
  `Markup` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dynamiccontrol
-- ----------------------------
INSERT INTO `dynamiccontrol` VALUES ('1', 'TextBlock', 'System.Windows.Controls.TextBlock', 'Control on wich text can be displayed', '<TextBlock xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" FontSize=\"18\" FontFamily=\"Segoe UI\" Text=\"Text\" />');
INSERT INTO `dynamiccontrol` VALUES ('2', 'TextBox', 'System.Windows.Controls.TextBox', 'Control no wich text can be input', null);
INSERT INTO `dynamiccontrol` VALUES ('3', 'Image', 'System.Windows.Controls.Image', 'Control on wich image can be displayed', '<Border xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" BorderBrush=\"Gray\" BorderThickness=\"1\"><Image Height=\"150\" Width=\"150\" Source=\"/SilentWebsite;component/Resources/empty.png\" Stretch=\"None\" /></Border>');
INSERT INTO `dynamiccontrol` VALUES ('4', 'CheckBox', 'System.Windows.Controls.CheckBox', 'Control wich holds checked/unchecked value', '<CheckBox xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" Content=\"CheckBox\" />');
INSERT INTO `dynamiccontrol` VALUES ('5', 'TabControl', 'System.Windows.Controls.TabControl', 'Control wich can hold tabs', null);
INSERT INTO `dynamiccontrol` VALUES ('6', 'Rectangle', 'System.Windows.Controls.Rectangle', 'Control that represents a simple rectangle', null);
INSERT INTO `dynamiccontrol` VALUES ('7', 'Label', 'System.Windows.Controls.Label', 'Control on wich text can be displayed', null);
INSERT INTO `dynamiccontrol` VALUES ('8', 'ComboBox', 'System.Windows.Controls.ComboBox', 'Control wich can hold a list of items to select', null);
INSERT INTO `dynamiccontrol` VALUES ('9', 'ListBox', 'System.Windows.Controls.ListBox', 'Control wich can hold a list of items', null);
INSERT INTO `dynamiccontrol` VALUES ('10', 'RadioButton', 'System.Windows.Controls.RadioButton', 'Control wich holds checked/unchecked value', null);

-- ----------------------------
-- Table structure for `projectpages`
-- ----------------------------
DROP TABLE IF EXISTS `projectpages`;
CREATE TABLE `projectpages` (
  `Id` bigint(20) NOT NULL,
  `ProjectId` bigint(20) NOT NULL,
  `AccessRights` int(11) NOT NULL,
  `Name` varchar(200) NOT NULL,
  `Markup` text NOT NULL,
  `Link` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `ProjectPagesRelation` (`ProjectId`),
  CONSTRAINT `ProjectPagesRelation` FOREIGN KEY (`ProjectId`) REFERENCES `projects` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of projectpages
-- ----------------------------

-- ----------------------------
-- Table structure for `projects`
-- ----------------------------
DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects` (
  `Id` bigint(20) NOT NULL,
  `UserId` bigint(20) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `AccessRights` int(20) NOT NULL,
  `Link` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `UserProjectRelation` (`UserId`),
  CONSTRAINT `UserProjectRelation` FOREIGN KEY (`UserId`) REFERENCES `users` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of projects
-- ----------------------------

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Email` varchar(200) NOT NULL,
  `UserName` varchar(200) NOT NULL,
  `Password` varchar(200) NOT NULL,
  `FullName` varchar(200) DEFAULT NULL,
  `DateOfBirth` date DEFAULT NULL,
  `Country` varchar(200) DEFAULT NULL,
  `City` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('8', 'sample@gmail.com', 'User1', '1', '', null, null, null);
INSERT INTO `users` VALUES ('9', 'sample2@gmail.com', 'User2', '1', '', '2013-03-30', '', '');
